ALTER VIEW [dbo].[View_CF_BizConfigOption]
AS
SELECT
         bo.BizConfigOptionGUID,
         bo.BizConfigGroupGUID,
         bo.BizConfigOptionName,
         bo.BizOptionType,
         bo.BizOptions,
         bo.BizOptionValue,
         bo.BizOptionOrder,
         bo.BizOptionScopeGUID,
         bo.TenantId,
         bo.IsDeleted,
         bo.CreateTime,
         bo.CreateGUID,
         bo.CreatedName,
         bo.ModifiedTime,
         bo.ModifiedGUID,
         bo.ModifiedName,
         bo.ApproveState,
         bo.ApproveGUID,
         bo.ApproveTime,
         bo.BuUnitGUID,
		 bo.BizOptionCode,
         bo.BizOptionRemark,
		 bg.BizConfigGroupName
FROM dbo.CF_BizConfigOption bo
LEFT JOIN dbo.CF_BizConfigGroup bg ON bo.BizConfigGroupGUID=bg.BizConfigGroupGUID